Strathcona Historic District
bordered by 88 Avenue in the north, 76 Avenue in the south, 111 Street in the west, and 102 Street in the east is full of trendy shopping and a vibrant nightlife cluster. The industrial chic place is centered on Whyte Avenue which is a major shopping district, but do not forget the amazing nightlife found in this corridor. This area is full of a lot of architecturally pleasing houses too. There is also a lot of historic commerical buildings that were once churches, different stores, different offices, and industrial. If this is what you are looking for, then Old Strathcona is your pick!
Edmonton Queen
The Queen is a riverboat which cruises up and down a small strip of the river near the city center. It is often seen as nothing more that a floating bar, with the food and service being substandard for the price.
Architecture
Whyte Ave
Outside of the area between 103 and 105 Street, upon first glance, there probably isn't anything that "pops". But, there are tons of architecture that's appealing, although it depends on your style. There is a bunch of historical buildings between 102 and 105 Str. NW that would please most. Aside from that there is some 1960s/early modern structures that are typical of that time frame. They are simple and use little detailing and elegant lines.
Mill Creek Architecture Walk
between 102 Street in the west, Whyte Ave in the south, 85 St. in the east and the river in the north. Check out any part in this area. This is a beautiful and cute, one-of-a-kind neighborhood lined with nice old-style houses and buildings, some refurbished and is home to a lot of infill, which means a lot of modern homes are being built. They come in funky styles and clash interestingly with the older structures. Great for someone interested in design because there's some really beautiful houses. Nice quiet walk.
University of Alberta
This area has a lot of architecture styles. It has some old gems near Sask Dr. A lot of it is brutalist buildings that once had horrible street access but have been retrofitted. There has also been recent development with some mediocre modern tecture.